﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Xiaov.SmartWeb.Application.PluginSrc.StatisticalSystem.Manage
{
    public partial class JYInfo : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                Response.Clear();
                string sql = "select y.jymc from jyqkb t,jyxx y where t.jyxxid=y.jyxxid and t.sfzq='否' and t.dwbm='" + Request.QueryString["dwbm"] + "' and t.nf=" + Request.QueryString["nf"] + " and t.yf=" + Request.QueryString["yf"] + " and y.bbbm='" + Request.QueryString["bbbm"] + "'";
                System.Data.DataSet ds = Maticsoft.DBUtility.DbHelperOra.Query(sql);
                string str = "";
                if (ds.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        str += "•" + ds.Tables[0].Rows[i][0].ToString() + "<br/>";
                    }
                    Response.Write(str);
                    HttpContext.Current.ApplicationInstance.CompleteRequest();

                }
                else
                {
                    throw new Exception("校验未通过,请返回该报表点击保存按钮!");
                }
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
                HttpContext.Current.ApplicationInstance.CompleteRequest();
            }
            finally
            {
                Response.End();
            }
        }
    }
}